CREATE TABLE [dbo].[GroupTypeRole]
(
[GroupTypeKey] [uniqueidentifier] NOT NULL,
[GroupRoleKey] [uniqueidentifier] NOT NULL,
[IsRequired] [bit] NOT NULL CONSTRAINT [DF_GroupTypeRole_IsRequired] DEFAULT ((0)),
[IsUnique] [bit] NOT NULL CONSTRAINT [DF_GroupTypeRole_IsUnique] DEFAULT ((0)),
[SortRank] [int] NULL,
[IsDefault] [bit] NOT NULL CONSTRAINT [DF_GroupTypeRole_IsDefault] DEFAULT ((0)),
[DefaultMemberStatusCode] [nvarchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IsSystem] [bit] NOT NULL CONSTRAINT [DF_GroupTypeRole_IsSystem] DEFAULT ((0)),
[GroupTypeRoleKey] [uniqueidentifier] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[GroupTypeRole] ADD CONSTRAINT [PK_GroupTypeRole] PRIMARY KEY CLUSTERED ([GroupTypeRoleKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GroupTypeRole] ADD CONSTRAINT [AK_GroupTypeRole] UNIQUE NONCLUSTERED ([GroupTypeKey], [GroupRoleKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_GroupTypeRole_DefaultMemberStatusCode] ON [dbo].[GroupTypeRole] ([DefaultMemberStatusCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GroupTypeRole] ADD CONSTRAINT [FK_GroupTypeRole_GroupMemberStatusRef] FOREIGN KEY ([DefaultMemberStatusCode]) REFERENCES [dbo].[GroupMemberStatusRef] ([GroupMemberStatusCode])
GO
ALTER TABLE [dbo].[GroupTypeRole] ADD CONSTRAINT [FK_GroupTypeRole_GroupRoleRef] FOREIGN KEY ([GroupRoleKey]) REFERENCES [dbo].[GroupRoleRef] ([GroupRoleKey])
GO
ALTER TABLE [dbo].[GroupTypeRole] ADD CONSTRAINT [FK_GroupTypeRole_GroupTypeRef] FOREIGN KEY ([GroupTypeKey]) REFERENCES [dbo].[GroupTypeRef] ([GroupTypeKey])
GO